<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>

<!DOCTYPE html>
<html>
<head id="MyHead">
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <script src="../resources/Scripts/jquery-1.8.3.min.js" type="text/javascript"></script>
    <script src="../resources/Scripts/JScriptIndex.js" type="text/javascript"></script>
    <script src="../resources/Scripts/jquery.easyui.min-1.3.5.js" type="text/javascript"></script>
    <link href="../resources/Content/Default.css" rel="stylesheet" type="text/css" />
    <link href="../resources/Content/IndexStyle.css" rel="stylesheet" type="text/css" />

        <link href="../resources/Res/easyui/themes/icon.css" rel="stylesheet" type="text/css" />
        <script src="../resources/Res/easyui/locale/easyui-lang-zh_CN.js" type="text/javascript"></script>
    <link href="../resources/Res/easyui/themes/default/easyui.css" rel="stylesheet" type="text/css" />
    <title>
	
    学员

</title>
     <script type="text/javascript" language="javascript">


        $(function () {
             $.extend($.fn.datagrid.methods, {
                 addToolbarItem: function (jq, items) {
                     return jq.each(function () {
                         var dpanel = $(this).datagrid('getPanel');
                         var toolbar = dpanel.children("div.datagrid-toolbar");
                         if (!toolbar.length) {
                             toolbar = $("<div class=\"datagrid-toolbar\"><table cellspacing=\"0\" cellpadding=\"0\"><tr></tr></table></div>").prependTo(dpanel);
                             $(this).datagrid('resize');
                         }
                         var tr = toolbar.find("tr");
                         for (var i = 0; i < items.length; i++) {
                             var btn = items[i];
                             if (btn == "-") {
                                 $("<td><div class=\"datagrid-btn-separator\"></div></td>").appendTo(tr);
                             } else {
                                 var td = $("<td></td>").appendTo(tr);
                                 var b = $("<a href=\"javascript:void(0)\"></a>").appendTo(td);
                                 b[0].onclick = eval(btn.handler || function () { });
                                 b.linkbutton($.extend({}, btn, {
                                     plain: true
                                 }));
                             }
                         }
                     });
                 },
                 removeToolbarItem: function (jq, param) {
                     return jq.each(function () {
                         var dpanel = $(this).datagrid('getPanel');
                         var toolbar = dpanel.children("div.datagrid-toolbar");
                         var cbtn = null;
                         if (typeof param == "number") {
                             cbtn = toolbar.find("td").eq(param).find('span.l-btn-text');
                         } else if (typeof param == "string") {
                             cbtn = toolbar.find("span.l-btn-text:contains('" + param + "')");
                         }
                         if (cbtn && cbtn.length > 0) {
                             cbtn.closest('td').remove();
                             cbtn = null;
                         }
                     });
                 }
             });
         });
    </script>
    
    

<script language="javascript" type="text/javascript">
    $(function () {
        setTimeout(function () { getData('Fenxiao'); }, 1000); //读取本月分点
        setTimeout(function () { getData('Baoming'); }, 2000); //读取本月分点
        setTimeout(function () { getData('Zhaosheng'); }, 3000); //读取本月分点
        setTimeout(function () { getData('Banbie'); }, 4000); //读取本月分点
    });
    $(function () {
        $.ajax({
            type: "POST",
            url: '../S_Class/getClass/@scid=' + $('#S_Carmodels').combobox("getValue"),
            dataType: 'json',
            success: function (jsonstr) {
                $("#fenxiaoID4").combobox({ data: jsonstr, editable: false, valueField: 'id', textField: 'text' });
                var data = $('#fenxiaoID4').combobox('getData');
                if (data.length > 0) {
                    $("#fenxiaoID4 ").combobox('select', data[0].id);
                }
            }
        });
    });

    function getData(str) {

        $('#flexigridData' + str).datagrid({
            //title: '预约列表', //列表的标题
            iconCls: 'icon-site',
            width: 'auto',
            height: 'auto',
            nowrap: true,
            striped: true,
            collapsible: true,
            loadMsg: '数据计算中,请稍等...',
            url: '/ZhaoShengDuibiTongji', //获取数据的url
            queryParams: { search: $('#' + str + 'Start_Time').val() + ',' + $('#' + str + 'End_Time').val() + ',' + str  },
            sortName: 'PK_ID',
            sortOrder: 'desc',
            idField: 'PK_ID',
            pageList: [1, 2, 3],
            pagination: true,
            rownumbers: true

        });

    }

    //内部学员查询
    function findData(str) {
        var Start_Time = $("#" + str + "Start_Time").val(); //关键字
        var End_Time = $("#" + str + "End_Time").val(); //关键字
        var fenxiaoID = $("#fenxiaoID1").combobox("getValue");

        if (Start_Time == "") {
            $.messager.alert("操作提示", "系统提示：请输入开始日期！", "info");
            return;
        }

        if (End_Time == "") {
            $.messager.alert("操作提示", "系统提示：请输入结束日期！", "info");
            return;
        }
        if (fenxiaoID == "") {
            fenxiaoID = "";
        }

        //执行查询
        //alert(search1);
        $('#flexigridData' + str).datagrid('reload', { search: Start_Time + ',' + End_Time + ',' + str + ',' + fenxiaoID });
    }
    function findDataBaoming(str) {
        var Start_Time = $("#" + str + "Start_Time").val(); //关键字
        var End_Time = $("#" + str + "End_Time").val(); //关键字
        var fenxiaoID = $("#fenxiaoID2").combobox("getValue");

        if (Start_Time == "") {
            $.messager.alert("操作提示", "系统提示：请输入开始日期！", "info");
            return;
        }

        if (End_Time == "") {
            $.messager.alert("操作提示", "系统提示：请输入结束日期！", "info");
            return;
        }
        if (fenxiaoID == "") {
            fenxiaoID = "";
        }
        //执行查询
        //alert(search1);
        $('#flexigridData' + str).datagrid('reload', { search: Start_Time + ',' + End_Time + ',' + str + ',' + fenxiaoID });
    }
    function findDataZhaosheng(str) {
        var Start_Time = $("#" + str + "Start_Time").val(); //关键字
        var End_Time = $("#" + str + "End_Time").val(); //关键字
        var fenxiaoID = $("#fenxiaoID3").combobox("getValue");

        if (Start_Time == "") {
            $.messager.alert("操作提示", "系统提示：请输入开始日期！", "info");
            return;
        }

        if (End_Time == "") {
            $.messager.alert("操作提示", "系统提示：请输入结束日期！", "info");
            return;
        }
        if (fenxiaoID == "") {
            fenxiaoID = "";
        }
        //执行查询
        //alert(search1);
        $('#flexigridData' + str).datagrid('reload', { search: Start_Time + ',' + End_Time + ',' + str + ',' + fenxiaoID });
    }
    function findDataBanbie(str) {
        var Start_Time = $("#" + str + "Start_Time").val(); //关键字
        var End_Time = $("#" + str + "End_Time").val(); //关键字
        var fenxiaoID = $("#fenxiaoID4").combobox("getValue");
		var SCarmodels=$("#S_Carmodels").combobox("getValue");
        if (Start_Time == "") {
            $.messager.alert("操作提示", "系统提示：请输入开始日期！", "info");
            return;
        }

        if (End_Time == "") {
            $.messager.alert("操作提示", "系统提示：请输入结束日期！", "info");
            return;
        }
        if (fenxiaoID == "") {
            fenxiaoID = "";
        }
        if (SCarmodels == "") {
        	SCarmodels = "";
        }
        //执行查询
        //alert(search1);
        $('#flexigridData' + str).datagrid('reload', { search: Start_Time + ',' + End_Time + ',' + str + ',' + SCarmodels +','+fenxiaoID });
    }
    function daochuExcel(strType) {

        if (confirm("系统提示：确认要导出吗？")) {
        	$.ajax({
				url : "/ZhaoshengDuibi"+strType,
				type : "post",
		/* 		data : $('#form1').serialize(), */
				dataType : "json",
				success : function(result) {
					console.log(result.msg)
					if (result.msg =='OK') {
						alert("导出成功！");
					/* 	parent.location.reload(); */
						
					}

				}
			});

           /*  window.location.href = "ZhaoshengDuibi" + strType; */
        }
        else {
            return false;
        }

    }

    </script>

<script src="../resources/Res/My97DatePicker/WdatePicker.js" type="text/javascript"></script>

      <base target = "_self">
</head>
<body>
       
    <div class="easyui-panel" fit="true" style="width:985px;height:563px;padding:5px;" border="false">
       
          <div class="easyui-tabs" data-options="tabWidth:160" fit="true">
       <div title="报名分校各月对比" style="padding:5px;">
             <table class="easyui-datagrid" id="flexigridDataFenxiao" data-options="fit:true" toolbar="#fenxiaoSearch">
                   <thead data-options="frozen:true">
                       <tr>
                           <th data-options="field:'fenxiao',width:100,align:'left',styler: function (value, row, index) {return 'background-color:#336699;color:white';} " rowspan="2">分校</th>

                       </tr>
                    </thead>
                    <thead>
                        <tr>
                           <th colspan="2">一月</th><th colspan="2">二月</th><th colspan="2">三月</th><th colspan="2">四月</th><th colspan="2">五月</th><th colspan="2">六月</th><th colspan="2">七月</th><th colspan="2">八月</th><th colspan="2">九月</th><th colspan="2">十月</th><th colspan="2">十一月</th><th colspan="2">十二月</th><th colspan="2">合计</th>
                       </tr>
                       <tr>
                       <th data-options="field:'shuliang0',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine0',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang1',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine1',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang2',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine2',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang3',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine3',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang4',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine4',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang5',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine5',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang6',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine6',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang7',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine7',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang8',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine8',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang9',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine9',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang10',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine10',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang11',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine11',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'hejiNum',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#b45b3e;color:white';}">数量</th><th data-options="field:'hejiJine',width:100,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#b45b3e;color:white';}">金额</th>
                        </tr>
                    </thead>
                </table>
        </div>
       <div title="报名来源各月对比" style="padding:5px;">
            <table id="flexigridDataBaoming" fit="true" toolbar="#fendianSearch">
            
                               <thead data-options="frozen:true">
                       <tr>
                           <th data-options="field:'fenxiao',width:100,align:'left',styler: function (value, row, index) {return 'background-color:#336699;color:white';}" rowspan="2">报名来源</th>

                       </tr>
                    </thead>
                    <thead>
                        <tr>
                           <th colspan="2">一月</th><th colspan="2">二月</th><th colspan="2">三月</th><th colspan="2">四月</th><th colspan="2">五月</th><th colspan="2">六月</th><th colspan="2">七月</th><th colspan="2">八月</th><th colspan="2">九月</th><th colspan="2">十月</th><th colspan="2">十一月</th><th colspan="2">十二月</th><th colspan="2">合计</th>
                
                       </tr>
                       <tr>
                       <th data-options="field:'shuliang0',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine0',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang1',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine1',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang2',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine2',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang3',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine3',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang4',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine4',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang5',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine5',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang6',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine6',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang7',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine7',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang8',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine8',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang9',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine9',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang10',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine10',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang11',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine11',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'hejiNum',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#b45b3e;color:white';}">数量</th><th data-options="field:'hejiJine',width:100,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#b45b3e;color:white';}">金额</th>
                        </tr>
                    </thead>

            </table>
       </div>
       <div title="招生来源各月对比" style="padding:5px;">
            <table id="flexigridDataZhaosheng" fit="true" toolbar="#laiyuanSearch">
            
                               <thead data-options="frozen:true">
                       <tr>
                           <th data-options="field:'fenxiao',width:100,align:'left',styler: function (value, row, index) {return 'background-color:#336699;color:white';}" rowspan="2">招生来源</th>

                       </tr>
                    </thead>
                    <thead>
                        <tr>
                           <th colspan="2">一月</th><th colspan="2">二月</th><th colspan="2">三月</th><th colspan="2">四月</th><th colspan="2">五月</th><th colspan="2">六月</th><th colspan="2">七月</th><th colspan="2">八月</th><th colspan="2">九月</th><th colspan="2">十月</th><th colspan="2">十一月</th><th colspan="2">十二月</th><th colspan="2">合计</th>
                
                       </tr>
                       <tr>
                       <th data-options="field:'shuliang0',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine0',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang1',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine1',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang2',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine2',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang3',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine3',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang4',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine4',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang5',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine5',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang6',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine6',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang7',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine7',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang8',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine8',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang9',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine9',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang10',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine10',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang11',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine11',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'hejiNum',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#b45b3e;color:white';}">数量</th><th data-options="field:'hejiJine',width:100,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#b45b3e;color:white';}">金额</th>
                        </tr>
                    </thead>

            </table>
       </div>

       <div title="班别各月对比" style="padding:5px;">
            <table id="flexigridDataBanbie" fit="true" toolbar="#banbieSearch">
            
                               <thead data-options="frozen:true">
                       <tr>
                           <th data-options="field:'fenxiao',width:100,align:'left',styler: function (value, row, index) {return 'background-color:#336699;color:white';}" rowspan="2">班别</th>

                       </tr>
                    </thead>
                    <thead>
                        <tr>
                           <th colspan="2">一月</th><th colspan="2">二月</th><th colspan="2">三月</th><th colspan="2">四月</th><th colspan="2">五月</th><th colspan="2">六月</th><th colspan="2">七月</th><th colspan="2">八月</th><th colspan="2">九月</th><th colspan="2">十月</th><th colspan="2">十一月</th><th colspan="2">十二月</th><th colspan="2">合计</th>
                
                       </tr>
                       <tr>
                       <th data-options="field:'shuliang0',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine0',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang1',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine1',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang2',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine2',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang3',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine3',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang4',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine4',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang5',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine5',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang6',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine6',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang7',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine7',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang8',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine8',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang9',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine9',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang10',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine10',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'shuliang11',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#d7fff0';} ">数量</th><th data-options="field:'jine11',width:60,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#f0dad2';}">金额</th><th data-options="field:'hejiNum',width:40,align:'right',styler: function (value, row, index) {return 'background-color:#b45b3e;color:white';}">数量</th><th data-options="field:'hejiJine',width:100,formatter: function (value, rec){return  formatCurrency(value)},align:'right',sortable:true,styler: function (value, row, index) {return 'background-color:#b45b3e;color:white';}">金额</th>
                        </tr>
                    </thead>

            </table>
       </div>
   </div> 
   </div>

<div id="fenxiaoSearch" style=" padding:5px;">
    <div class="row">
        <span>&nbsp;报名日期：</span><input class="input-textbox" onclick="WdatePicker({maxDate:'#F{$dp.$D(\'FenxiaoEnd_Time\');}'})"  type="text" id="FenxiaoStart_Time" value='2018-01-01' size="10" />
        &nbsp;到&nbsp;&nbsp;<input class="input-textbox" onclick="WdatePicker({minDate:'#F{$dp.$D(\'FenxiaoStart_Time\');}'})"  type="text" id="FenxiaoEnd_Time" value='2018-12-31' size="10" />
       &nbsp;&nbsp;所属分校：<select class="easyui-combobox" id="fenxiaoID1" name="fenxiaoID1" style="width:100px;"><option value="">请选择</option>
<option value="总校">总校</option>
<option value="挂考">挂靠</option>
</select>
        &nbsp;<a href="javascript:findData('Fenxiao');" class="easyui-linkbutton" data-options="iconCls:'icon-search'">统计</a>
         &nbsp;<a href="javascript:daochuExcel('FenXiao');" class="easyui-linkbutton" data-options="iconCls:'icon-search'">导出EXCEL</a>
    </div>
</div>

<div id="fendianSearch" style=" padding:5px;">
    <div class="row">
        <span>&nbsp;报名日期：</span><input class="input-textbox" onclick="WdatePicker({maxDate:'#F{$dp.$D(\'BaomingEnd_Time\');}'})"  type="text" id="BaomingStart_Time" value='2018-01-01' size="10" />
        &nbsp;到&nbsp;&nbsp;<input class="input-textbox" onclick="WdatePicker({minDate:'#F{$dp.$D(\'BaomingStart_Time\');}'})"  type="text" id="BaomingEnd_Time" value='2018-12-31' size="10" />
         &nbsp;&nbsp;报名来源：<select class="easyui-combobox" id="fenxiaoID2" name="fenxiaoID2" style="width:100px;"><option value="大厅">大厅</option>
<option value="业务组">业务组</option>
<option value="教练组">教练组</option>
<option value="其他部门">其他部门</option>
</select>
        &nbsp;<a href="javascript:findDataBaoming('Baoming');" class="easyui-linkbutton" data-options="iconCls:'icon-search'">统计</a>
         &nbsp;<a href="javascript:daochuExcel('BaoMing');" class="easyui-linkbutton" data-options="iconCls:'icon-search'">导出EXCEL</a>
    </div>
</div>

<div id="laiyuanSearch" style=" padding:5px;">
    <div class="row">
        <span>&nbsp;报名日期：</span><input class="input-textbox" onclick="WdatePicker({maxDate:'#F{$dp.$D(\'ZhaoshengEnd_Time\');}'})"  type="text" id="ZhaoshengStart_Time" value='2018-01-01' size="10" />
        &nbsp;到&nbsp;&nbsp;<input class="input-textbox" onclick="WdatePicker({minDate:'#F{$dp.$D(\'ZhaoshengStart_Time\');}'})"  type="text" id="ZhaoshengEnd_Time" value='2018-12-31' size="10" />
        &nbsp;&nbsp;招生来源：<select class="easyui-combobox" id="fenxiaoID3" name="fenxiaoID3" style="width:110px;">
<option value="电视广告">电视广告</option>
<option value="网站推广">网站推广</option>
</select>
        &nbsp;<a href="javascript:findDataZhaosheng('Zhaosheng');" class="easyui-linkbutton" data-options="iconCls:'icon-search'">统计</a>
        &nbsp;<a href="javascript:daochuExcel('ZhaoSheng');" class="easyui-linkbutton" data-options="iconCls:'icon-search'">导出EXCEL</a>
    </div>
</div>


<div id="banbieSearch" style=" padding:5px;">
    <div class="row">
        <span>&nbsp;报名日期：</span><input class="input-textbox" onclick="WdatePicker({maxDate:'#F{$dp.$D(\'BanbieEnd_Time\');}'})"  type="text" id="BanbieStart_Time" value='2018-01-01' size="10" />
        &nbsp;到&nbsp;&nbsp;<input class="input-textbox" onclick="WdatePicker({minDate:'#F{$dp.$D(\'BanbieStart_Time\');}'})"  type="text" id="BanbieEnd_Time" value='2018-12-31' size="10" />
         &nbsp;&nbsp;准驾车型：<select class="easyui-combobox" id="S_Carmodels" name="S_Carmodels" style="width:150px;"><option value="C1">C1</option>
<option value="C2">C2</option>
</select>
         &nbsp;&nbsp;班级名称：<select class="easyui-combobox" data-val="true" data-val-length="长度不可超过50" data-val-length-max="50" panelHeight="auto" id="fenxiaoID4" name="fenxiaoID4" style="width:100px;"><option value='1'>---请选择---</option><option value='C1普通班'>---C1普通班---</option>
         <option value='C1贵宾班'>---C1贵宾班---</option></select>
        &nbsp;<a href="javascript:findDataBanbie('Banbie');" class="easyui-linkbutton" data-options="iconCls:'icon-search'">统计</a>
        &nbsp;<a href="javascript:daochuExcel('BanBie');" class="easyui-linkbutton" data-options="iconCls:'icon-search'">导出EXCEL</a>
    </div>
</div>


</body>
</html>
